SQLConnect Floating Point Exception

SQLConnect Floating Point Exception

am 15.04.2011 22:46:21 von mike.rawlins

--_004_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B595766AME RICASMAIL0_"

--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

All,

Trying to use MySQL ODBC drivers on RHE Linux to connect from a user writte=
n program to MySQL database on a remote machine. I downloaded the latest d=
rivers this past week, and unixODBC refreshed on machine a few days ago. =
I have small demo program I'm trying to make work before we bring up the fu=
ll application.

I can step through the code OK through SQLSetConnectOption, but when I hit =
SQLConnect it throws a floating point exception.

If I hack the name of the driver file in $ODBCINI the program can't find th=
e driver, so I suspect it's actually getting into the driver.

Any ideas?

Here's my (sanitized) odbc.ini file:

[ODBC Data Sources]
MIKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL

[MIKEMYSQL]
driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so
description=3DConnector ODBC 3.51 Driver DSN
server=3Dxxx.xxx.com
port=3D3306
database=3DYY53
option=3D0


Thanks,

Mike


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFB83.97F87080]


--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:sche=
mas-microsoft-com:office:smarttags"> ontent=3D"text/html; charset=3Dus-ascii"> Microsoft Word 12 (filtered medium)"> nk=3Dpurple>

INK2"> E_LINK3">All,

 

<=
p class=3DMsoNormal>Trying to use MySQL ODBC drivers on RHE Linux to connec=
t from a user written program to MySQL database on a remote machine.  =
I downloaded the latest drivers this past week, and unixODBC refreshed on m=
achine a few days ago.   I have small demo program I’m tryi=
ng to make work before we bring up the full application.

lass=3DMsoNormal> 

I can step throu=
gh the code OK through SQLSetConnectOption, but when I hit SQLConnect it th=
rows a floating point exception.

&n=
bsp;

If I hack the name of the driver file in=
$ODBCINI the program can’t find the driver, so I suspect it’s =
actually getting into the driver.

&=
nbsp;

Any ideas?

Normal> 

Here’s my (sanitized=
) odbc.ini file:

 

class=3DMsoNormal>[ODBC Data Sources]

M=
IKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL

mal> 

[MIKEMYSQL]

class=3DMsoNormal>driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc 5.so=

description=3DConnector ODBC 3.51 Driver DSN<=
/o:p>

server=3Dxxx.xxx.com

=3DMsoNormal>port=3D3306

database=3DYY53=

option=3D0

Normal> 

 

ass=3DMsoNormal>Thanks,

  >

Mike

&nbs=
p;

y:"Verdana","sans-serif";color:gray'> 

=3DMsoNormal> if";color:gray'>Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Tec=
hnical Assessment Subcommittee

pan style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"' > t>18111 Preston Road, Suite 600
=
Dallas, T=
X 75252
+1 972.643.3101 direct 9.0pt;font-family:"Verdana","sans-serif";color:gray'>=

a","sans-serif";color:#999999'> inovis.com" title=3D"mailto:jay.melton@inovis.com"> 'color:#999999'>mike.rawlins@gxs.com =3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'>=

amily:"Verdana","sans-serif";color:#999999'> m/">www.gxs.com <=
span lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; =
color:#999999'>

nt-size:9.0pt;font-family:"Verdana","sans-serif";color:#9999 99'> http://blogs.inovis.com/">GXS Blog<=
/span> ana","sans-serif";color:#999999'>

> image001.gif@01CBFB83.97F87080" alt=3D"GXS_2color_pos">

ass=3DMsoNormal> 

=

--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_--

--_004_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_--

RE: SQLConnect Floating Point Exception

am 15.04.2011 22:47:40 von mike.rawlins

--_004_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B59576CAME RICASMAIL0_"

--_000_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Another bit of info - the program works fine with different drivers connect=
ing to other databases.


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFB84.72417B60]

From: mike.rawlins@gxs.com [mailto:mike.rawlins@gxs.com]
Sent: Friday, April 15, 2011 3:46 PM
To: myodbc@lists.mysql.com
Subject: SQLConnect Floating Point Exception

All,

Trying to use MySQL ODBC drivers on RHE Linux to connect from a user writte=
n program to MySQL database on a remote machine. I downloaded the latest d=
rivers this past week, and unixODBC refreshed on machine a few days ago. =
I have small demo program I'm trying to make work before we bring up the fu=
ll application.

I can step through the code OK through SQLSetConnectOption, but when I hit =
SQLConnect it throws a floating point exception.

If I hack the name of the driver file in $ODBCINI the program can't find th=
e driver, so I suspect it's actually getting into the driver.

Any ideas?

Here's my (sanitized) odbc.ini file:

[ODBC Data Sources]
MIKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL

[MIKEMYSQL]
driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so
description=3DConnector ODBC 3.51 Driver DSN
server=3Dxxx.xxx.com
port=3D3306
database=3DYY53
option=3D0


Thanks,

Mike


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFB83.97F87080]


--_000_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:sche=
mas-microsoft-com:office:smarttags"> ontent=3D"text/html; charset=3Dus-ascii"> Microsoft Word 12 (filtered medium)"> nk=3Dpurple>

olor:#1F497D'>Another bit of info - the program works fine with different d=
rivers connecting to other databases.

rmal> 

s=3DMsoNormal> erif";color:gray'> 

yle=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";co lor:gray'>Mike =
Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Sub=
committee

e:9.0pt;font-family:"Verdana","sans-serif"'> style=3D'color:gray'>18111 Preston Road, Suite 600
=
Dallas, TX 75252
+1 972.643=
..3101 direct rdana","sans-serif";color:gray'>

mal> :#999999'> mailto:jay.melton@inovis.com">mike.=
rawlins@gxs.com ont-family:"Verdana","sans-serif";color:#999999'>

lass=3DMsoNormal> -serif";color:#999999'> tyle=3D'color:#999999'>www.gxs.com =3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'>=

amily:"Verdana","sans-serif";color:#999999'> com/">GXS Blog an lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; co=
lor:#999999'>

r:#1F497D'> =3D"cid:image001.gif@01CBFB84.72417B60" alt=3D"GXS_2color_pos"><=
/span>

&nb=
sp;

1.0pt;padding:3.0pt 0in 0in 0in'>

nt-size:10.0pt;font-family:"Tahoma","sans-serif"'>From: le=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mike.rawlins@gxs=
..com [mailto:mike.rawlins@gxs.com]
Sent: Friday, April 15, 2011 =
3:46 PM
To: myodbc@lists.mysql.com
Subject: SQLConnect =
Floating Point Exception

mal> 

name=3D"OLE_LINK2">=
All,

 

Normal>Trying to use MySQL ODBC drivers on RHE Linux to connect from a user=
written program to MySQL database on a remote machine.  I downloaded =
the latest drivers this past week, and unixODBC refreshed on machine a few =
days ago.   I have small demo program I’m trying to make wo=
rk before we bring up the full application.

mal> 

I can step through the code O=
K through SQLSetConnectOption, but when I hit SQLConnect it throws a floati=
ng point exception.

  >

If I hack the name of the driver file in $ODBCINI the=
program can’t find the driver, so I suspect it’s actually gett=
ing into the driver.

  p>

Any ideas?

&=
nbsp;

Here’s my (sanitized) odbc.ini fi=
le:

 

ormal>[ODBC Data Sources]

MIKEMYSQL=3DMy=
ODBC 3.51 Driver DSN for MySQL

&nbs=
p;

[MIKEMYSQL]

rmal>driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so

=3DMsoNormal>description=3DConnector ODBC 3.51 Driver DSN

class=3DMsoNormal>server=3Dxxx.xxx.com

p=
ort=3D3306

database=3DYY53 >

option=3D0

&n=
bsp;

 

l>Thanks,

 

=3DMsoNormal>Mike

 

<=
p class=3DMsoNormal> sans-serif";color:gray'> 

pan style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; color:gray'=
>Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessme=
nt Subcommittee

nt-size:9.0pt;font-family:"Verdana","sans-serif"'>=
18111 Preston Road, Suite 600
 dress>Dallas, TX 75252
+1 9=
72.643.3101 direct

=
9999'> to:jay.melton@inovis.com">mike.rawl=
ins@gxs.com family:"Verdana","sans-serif";color:#999999'>

=3DMsoNormal> if";color:#999999'> =3D'color:#999999'>www.gxs.com ont-size:9.0pt;font-family:"Verdana","sans-serif";color:#999 999'> >

:"Verdana","sans-serif";color:#999999'> >GXS Blog ng=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; color:#=
999999'>

175 height=3D88 id=3D"Picture_x0020_1" src=3D"cid:image001.gif@01CBFB83.97F=
87080" alt=3D"GXS_2color_pos">

&nbs=
p;

=

--_000_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_--

--_004_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_--

RE: SQLConnect Floating Point Exception

am 20.04.2011 18:43:33 von mike.rawlins

--_004_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B89FD46AME RICASMAIL0_"

--_000_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

FYI - Problem solved. Since I tried different things I'm not exactly sure w=
hat fixed it, but I think it probably had something to do with my systems a=
dmin person moving the ODBC drivers to /usr/lib and running the myodbc-inst=
aller program.


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFF50.2AF02980]

From: Rawlins, Mike (GXS)
Sent: Friday, April 15, 2011 3:48 PM
To: Rawlins, Mike (GXS); myodbc@lists.mysql.com
Subject: RE: SQLConnect Floating Point Exception

Another bit of info - the program works fine with different drivers connect=
ing to other databases.


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFF50.2AF02980]

From: mike.rawlins@gxs.com [mailto:mike.rawlins@gxs.com]
Sent: Friday, April 15, 2011 3:46 PM
To: myodbc@lists.mysql.com
Subject: SQLConnect Floating Point Exception

All,

Trying to use MySQL ODBC drivers on RHE Linux to connect from a user writte=
n program to MySQL database on a remote machine. I downloaded the latest d=
rivers this past week, and unixODBC refreshed on machine a few days ago. =
I have small demo program I'm trying to make work before we bring up the fu=
ll application.

I can step through the code OK through SQLSetConnectOption, but when I hit =
SQLConnect it throws a floating point exception.

If I hack the name of the driver file in $ODBCINI the program can't find th=
e driver, so I suspect it's actually getting into the driver.

Any ideas?

Here's my (sanitized) odbc.ini file:

[ODBC Data Sources]
MIKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL

[MIKEMYSQL]
driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so
description=3DConnector ODBC 3.51 Driver DSN
server=3Dxxx.xxx.com
port=3D3306
database=3DYY53
option=3D0


Thanks,

Mike


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFB83.97F87080]


--_000_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:sche=
mas-microsoft-com:office:smarttags"> ontent=3D"text/html; charset=3Dus-ascii"> Microsoft Word 12 (filtered medium)"> nk=3Dpurple>

olor:#1F497D'>FYI - Problem solved. Since I tried different things I’=
m not exactly sure what fixed it, but I think it probably had something to =
do with my systems admin person moving the ODBC drivers to /usr/lib and run=
ning the myodbc-installer program.

l> 

=3DMsoNormal> rif";color:gray'> 

le=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";col or:gray'>Mike R=
awlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subc=
ommittee

:9.0pt;font-family:"Verdana","sans-serif"'> tyle=3D'color:gray'>18111 Preston Road, Suite 600
<=
/ns0:Street>Dallas, TX 75252
+1 972.643.=
3101 direct dana","sans-serif";color:gray'>

al> #999999'> ailto:jay.melton@inovis.com">mike.r=
awlins@gxs.com nt-family:"Verdana","sans-serif";color:#999999'>

ass=3DMsoNormal> serif";color:#999999'> yle=3D'color:#999999'>www.gxs.com =3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'>=

amily:"Verdana","sans-serif";color:#999999'> com/">GXS Blog an lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; co=
lor:#999999'>

r:#1F497D'> =3D"cid:image001.gif@01CBFF50.2AF02980" alt=3D"GXS_2color_pos"><=
/span>

&nb=
sp;

1.0pt;padding:3.0pt 0in 0in 0in'>

nt-size:10.0pt;font-family:"Tahoma","sans-serif"'>From: le=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Rawlins, Mike (G=
XS)
Sent: Friday, April 15, 2011 3:48 PM
To: Rawlins, =
Mike (GXS); myodbc@lists.mysql.com
Subject: RE: SQLConnect Floati=
ng Point Exception

:p> 

Anoth=
er bit of info - the program works fine with different drivers connecting t=
o other databases.

'color:#1F497D'> 

style=3D'font-size:10.0pt;font-family:"Verdana","sans-serif" ;color:gray'><=
o:p> 

0pt;font-family:"Verdana","sans-serif";color:gray'>Mike Rawlins
Sr. Soft=
ware Engineer
Chair, ASC X12 Technical Assessment Subcommittee >

:"Verdana","sans-serif"'> '>18111 Preston Road, Suite 600
 style=3D'color:gray'>Dallas, TX 75252
+1 972.643.3101 direct >

9.0pt;font-family:"Verdana","sans-serif";color:#999999'> ike.rawlins@mike.rawlins@inovis.com" title=3D"mailto:jay.melton@inovis.com"=
>mike.rawlins@gxs.com pan> rif";color:#999999'>

=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'> ef=3D"http://www.inovis.com/">www.g=
xs.com ly:"Verdana","sans-serif";color:#999999'>

soNormal> color:#999999'> =3D'color:#999999'>GXS Blog size:9.0pt;font-family:"Verdana","sans-serif";color:#999999' > pan>

width=3D175 height=3D88 id=3D"_x0000_i1025" src=3D"cid:image001.gif@01CBFF5=
0.2AF02980" alt=3D"GXS_2color_pos">

soNormal> 

v style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in=
0in'>

Tahoma","sans-serif"'>From: family:"Tahoma","sans-serif"'> mike.rawlins@gxs.com [mailto:mike.rawlins@gx=
s.com]
Sent: Friday, April 15, 2011 3:46 PM
To: myodbc=
@lists.mysql.com
Subject: SQLConnect Floating Point Exception >

 

class=3DMsoNormal> me=3D"OLE_LINK1">All,

=3DMsoNormal> 

Trying to use MySQL =
ODBC drivers on RHE Linux to connect from a user written program to MySQL d=
atabase on a remote machine.  I downloaded the latest drivers this pas=
t week, and unixODBC refreshed on machine a few days ago.   I hav=
e small demo program I’m trying to make work before we bring up the f=
ull application.

 

class=3DMsoNormal>I can step through the code OK through SQLSetConnectOpti=
on, but when I hit SQLConnect it throws a floating point exception. :p>

 

If I =
hack the name of the driver file in $ODBCINI the program can’t find t=
he driver, so I suspect it’s actually getting into the driver. o:p>

 

Any =
ideas?

 

soNormal>Here’s my (sanitized) odbc.ini file:

=3DMsoNormal> 

[ODBC Data Sources]<=
o:p>

MIKEMYSQL=3DMyODBC 3.51 Driver DSN for M=
ySQL

 

Normal>[MIKEMYSQL]

driver=3D/XXX/xxx/mys=
ql-odbc/lib/libmyodbc5.so

description=3D=
Connector ODBC 3.51 Driver DSN

server=3D=
xxx.xxx.com

port=3D3306

class=3DMsoNormal>database=3DYY53

optio=
n=3D0

 

oNormal> 

Thanks,

class=3DMsoNormal> 

Mike=

 

yle=3D'font-size:10.0pt;font-family:"Verdana","sans-serif";c olor:gray'> > 

;font-family:"Verdana","sans-serif";color:gray'>Mike Rawlins
Sr. Softwar=
e Engineer
Chair, ASC X12 Technical Assessment Subcommittee span>

erdana","sans-serif"'>1=
8111 Preston Road, Suite 600
 le=3D'color:gray'>Dallas, TX 75252
+1 972.643.3101 direct o:p>

pt;font-family:"Verdana","sans-serif";color:#999999'> ..rawlins@mike.rawlins@inovis.com" title=3D"mailto:jay.melton@inovis.com"> pan lang=3DFR style=3D'color:#999999'>mike.rawlins@gxs.com > ";color:#999999'>

font-size:9.0pt;font-family:"Verdana","sans-serif";color:#99 9999'> =3D"http://www.inovis.com/">www.gxs=
..com :"Verdana","sans-serif";color:#999999'>

Normal> lor:#999999'> color:#999999'>GXS Blog :9.0pt;font-family:"Verdana","sans-serif";color:#999999'>=

ure_x0020_1" src=3D"cid:image001.gif@01CBFB83.97F87080" alt=3D"GXS_2color_p=
os">

 

<=
/html>=

--_000_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_--

--_004_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_--